home *** CD-ROM | disk | FTP | other *** search
/ Internet.Works 40 / Issue 40.iso / pc / Tutorial / Database / dbdrilldown_Result.cfm < prev    next >
Encoding:
Text File  |  2000-11-07  |  1.6 KB  |  63 lines

  1. <!--- Create Criteria string for query from data entered thru search form --->
  2. <CFSET Criteria = ''>
  3. <CF_dbdrilldown_AppendCriteria
  4.     FieldName="#Form.Crit1_FieldName#"
  5.     FieldType="#Form.Crit1_FieldType#"
  6.     Operator="#Form.Crit1_Operator#"
  7.     Value="#Form.Crit1_Value#">
  8. <CF_dbdrilldown_AppendCriteria
  9.     FieldName="#Form.Crit2_FieldName#"
  10.     FieldType="#Form.Crit2_FieldType#"
  11.     Operator="#Form.Crit2_Operator#"
  12.     Value="#Form.Crit2_Value#">
  13. <CF_dbdrilldown_AppendCriteria
  14.     FieldName="#Form.Crit3_FieldName#"
  15.     FieldType="#Form.Crit3_FieldType#"
  16.     Operator="#Form.Crit3_Operator#"
  17.     Value="#Form.Crit3_Value#">
  18.  
  19.  
  20. <!--- Query returning search results --->
  21. <CFQUERY name="SearchResult" dataSource="hotel">
  22.     SELECT DISTINCT hotels.HotelName AS ResultField1, hotels.StarRating AS ResultField2, hotels.City AS ResultField3, hotels.HotelID AS ID_Field
  23.     FROM hotels
  24.     WHERE 
  25.         #PreserveSingleQuotes(Criteria)#
  26. </CFQUERY>
  27.  
  28.  
  29. <HTML><HEAD>
  30.     <TITLE>db drilldown - Search Result</TITLE>
  31. </HEAD><BODY bgcolor="ffffff">
  32.  
  33.  
  34. <FONT size="+1">db drilldown</FONT> <BR>
  35. <FONT size="+2"><B>Search Result</B></FONT>
  36.  
  37. <P>
  38.  
  39. <TABLE border=0 cellpadding=3 cellspacing=0>
  40.  
  41. <TR bgcolor="cccccc">
  42.     <TD> </TD>
  43.     <TD>HotelName</TD>
  44.     <TD>StarRating</TD>
  45.     <TD>City</TD>
  46.  
  47. </TR>
  48.  
  49. <CFOUTPUT query="SearchResult">
  50. <TR bgcolor="#IIf(CurrentRow Mod 2, DE('ffffff'), DE('ffffcf'))#">
  51.     <TD><A href="dbdrilldown_Detail.cfm?ID=#URLEncodedFormat(ID_Field)#">[detail]</A></TD>
  52.     <TD>#ResultField1#</TD>
  53. <TD>#ResultField2#</TD>
  54. <TD>#ResultField3#</TD>
  55.  
  56. </TR>
  57. </CFOUTPUT>
  58.  
  59. </TABLE>
  60.  
  61.  
  62. </BODY></HTML>
  63.